package com.ezcolour.ticket.dao;

import com.ezcolour.ticket.model.Menu;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface MenuDao extends JpaRepository<Menu,Long> {
    @Query("select m.url from Relation rel inner join Menu m on rel.menuId = m.id where rel.roleId = ?1 ")
    List<String> getResUrlsByRoleId(Long roid);
}
